<?php
	class Constants{

		const regex = '/([^a-zA-Z\d])|(\s|\(|\))/';

		const FOOD_TABLE = 'food';
		const FOOD_HISTORY = 'food_history';
		const QUICK_ADD = 'quick_add_pts';
		const FOOD_FAVORITE = 'food_favorite';
		const PROFILE_TABLE = 'profile';
		const POINTS_TABLE = 'points';

		const USER_ID = 'user_id';
		const FIRST_NAME = 'first_name';
		const LAST_NAME = 'last_name';
		const GENDER = 'gender';
		const BIRTHDATE = 'birthdate';
		const EMAIL = 'email';
		const WEIGHT = 'weight';
		const HEIGHT = 'height';
		const GOAL_WEIGHT = 'goal_weight';
		const GOAL_DATE = 'goal_date';
		const POINTS_ID = 'points_id';
		const USER_NAME = 'username';
		const PASSWORD = 'user_pw';


		const NUM_OF_COLUMNS_IN_FOOD_HISTORY = 6;//this shoulc be equal to the number of columns directly listed below
		const PROFILE_ID = 'user_id';
		const FOOD_HISTORY_ID = 'food_id';
		const QUICK_ID = 'quick_add_id';
		const FOOD_DATE = 'food_date';
		const MEAL_TIME = 'meal_time';
		const MEAL_SERVING_SIZE = 'meal_serving_size';

		const FOOD_ID = 'id';
		const FOOD_NAME = 'name';
		const FOOD_TYPE = 'type';
		const FOOD_CAL = 'calories';
		const FOOD_FAT = 'fat';
		const FOOD_FIBER = 'fiber';
		const FOOD_POINTS = 'points';
		const FOOD_CREATED_BY = 'created_by';
		const FOOD_DT_CREATED = 'date_created';
		const FOOD_DT_MODIFIED = 'date_modified';

		const QUICK_FOOD_NAME = 'quick_name';
		const QUICK_FOOD_POINTS = 'quick_points';

		const FOOD_FAV_SERVING_SIZE = 'fav_serving_size';


		const DAILY_PTS = 'daily_pts';
		const DAILY_PTS_REM = 'daily_pts_rem';
		const WEEKLY_PTS = 'weekly_pts_rem';
		const WEEKLY_PTS_REM = 'weekly_pts_rem';
		const ACTIVITY_PTS = 'activity_pts';
		const ACTIVITY_PTS_REM = 'activity_pts_rem';
		const START_DATE = 'start_date';
		const END_DATE = 'end_date';


	}
?>